Business intelligence solutions can be complicated to implement because they require:
■ Understanding online analytical processing (OLAP) concepts and implementation.
■ Setting up special OLAP databases: the data warehouse and the analysis database.
■ Configuring and scheduling Integration Services packages that periodically extract data from your iMIS database, load the data into your data warehouse, and transform the contents of your data warehouse into cubes in the analysis database.
■ Learning and using OLAP viewer software to analyze the cubes in your analysis database.
Depending on your organization's experience with implementing business intelligence solutions, you might involve ASI Consulting to ensure you achieve your business intelligence goals quickly.